omc0036 - address omc0036 NUTS 3 region mandatory

Card of business rule address omc0036 NUTS 3 region mandatory

Name

address omc0036 NUTS 3 region mandatory

Code

omc0036

Comment

NUTS 3 region of the address is mandatory when the foreign counterparty is in a reporting member state.

ECB Validation identifier: CY0090

Rule Type

Constraint


Server expression of the business rule address omc0036 NUTS 3 region mandatory

(if (('address'.'reporting agent identifier' = 'foreign counterparty'.'reporting agent identifier') and
('address'.'street' = 'foreign counterparty'.'address street') and
('address'.'city / town / village' = 'foreign counterparty'.'address city / town / village') and
('address'.'postal code' = 'foreign counterparty'.'address postal code') and
('address'.'country' = 'foreign counterparty'.'address country') and
('foreign counterparty'.'reporting reference date' = 'counterparty'.'reporting reference date') and
('foreign counterparty'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier') and
('foreign counterparty'.'counterparty identifier' = 'counterparty'.'counterparty identifier') and
((('counterparty'.'reporting reference date' = 'part of legal entity'.'reporting reference date') and
('counterparty'.'reporting agent identifier' = 'part of legal entity'.'reporting agent identifier') and
('counterparty'.'counterparty identifier' = 'part of legal entity'.'counterparty identifier') and
('part of legal entity'.'reporting reference date' = 'foreign branch in reporting member state'.'reporting reference date') and
('part of legal entity'.'reporting agent identifier' = 'foreign branch in reporting member state'.'reporting agent identifier') and
('part of legal entity'.'counterparty identifier' = 'foreign branch in reporting member state'.'counterparty identifier'))
or
(('counterparty'.'reporting reference date' = 'legal entity'.'reporting reference date') and
('counterparty'.'reporting agent identifier' = 'legal entity'.'reporting agent identifier') and
('counterparty'.'counterparty identifier' = 'legal entity'.'counterparty identifier') and
('legal entity'.'reporting reference date' = 'foreign legal entity'.'reporting reference date') and
('legal entity'.'reporting agent identifier' = 'foreign legal entity'.'reporting agent identifier') and
('legal entity'.'counterparty identifier' = 'foreign legal entity'.'counterparty identifier'))))
then (('address'.'NUTS 3 region' <> null)))


List of DNB-specific attributes of the business rule address omc0036 NUTS 3 region mandatory

Name

Value

business rule classification

other model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

1

severity

blocking


List of attached objects of the business rule address omc0036 NUTS 3 region mandatory

Short Description

Entity Attribute 'address.NUTS 3 region'